UPDATE dbo.userinfo
SET password = '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA'

SET IDENTITY_INSERT LINK ON

INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'1', N'1', N'Add Donor', N'showAddDonor.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'3', N'3', N'Donor List', N'showDonorList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'26', N'2', N'Edit Donor', N'searchDonor.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'27', N'4', N'Add Donor Award', N'showAddDonoraward.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'28', N'5', N'Find Donor Award', N'findDonoraward.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'29', N'3', N'View Donor Awards', N'showDonorawardList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'30', N'1', N'Add Project', N'showAddCipeproject.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'31', N'2', N'Find Project', N'findCipeproject.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'32', N'3', N'View Projects / Grants', N'showCipeprojectList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'33', N'1', N'Add Partner', N'showAddPartnergrant.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'34', N'2', N'Edit Partner', N'searchPartner.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'35', N'3', N'View Partner', N'showPartnerList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'36', N'1', N'Enter Financial and Narrative Reporting Requirements', N'showAddFinNarRepReq.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'37', N'2', N'Edit Financial and Narrative Reporting Requirements', N'showEditFinNarRepReq.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'38', N'1', N'Enter Audit Details', N'showAddAudit.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'39', N'2', N'Edit Audit Details', N'searchAudit.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'40', N'3', N'View Audits', N'showAuditList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'41', N'1', N'Add Payment Request', N'showAddPaymentrequest.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'42', N'2', N'Find Payment Request', N'findPaymentrequest.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'43', N'3', N'View Payment Requests', N'showPaymentrequestList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'44', N'4', N'Process Payment Request', N'processPaymentReq.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'45', N'5', N'Instructions', N'showInstructionsPaymentReq.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'46', N'1', N'Add Payee', N'showAddPayee.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'47', N'2', N'Edit Payee', N'searchPayee.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'48', N'3', N'View Payee''s', N'showPayeeList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'49', N'1', N'Reports List', N'showReportList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'50', N'1', N'Email Grants Management', N'showEmailGrantManagement.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'51', N'2', N'Report Computer Problem to Help Desk', N'reportComputerProblem.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'52', N'3', N'CMRS System Requests - Add User, etc.', N'systemReq.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'53', N'3', N'Manage Roles', N'showAddRole.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'54', N'4', N'View Roles', N'showRoleList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'55', N'31', N'Manage KM Organization Types', N'showAddOrganizationtype.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'57', N'1', N'Manage Users', N'showAddUser.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'58', N'2', N'View Users', N'showUserList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'59', N'3', N'Enter Partner Monitoring Details', N'showAddPartnerMonDetail.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'60', N'4', N'Edit Partner Monitoring Details', N'showEditPartnerMonDetail.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'61', N'5', N'View Partner Monitoring Details', N'showPartnerMonDetail.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'62', N'29', N'Manage Account Codes', N'showAddAccountCode.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'63', N'5', N'Manage Regions', N'showAddRegion.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'64', N'15', N'Manage Donor Award Statuses', N'showAddDonorawardstatus.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'65', N'13', N'Manage Donor Award Types', N'showAddDonorawardtype.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'66', N'19', N'Manage Project Statuses', N'showAddCipeprojectstatus.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'67', N'17', N'Manage Project Types', N'showAddCipeprojecttype.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'68', N'23', N'Manage Partner Grant Statuses', N'showPageHeading.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'69', N'21', N'Manage Partner Grant Types', N'showPageHeading.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'70', N'27', N'Manage Payment Request Statuses', N'showAddPaymentrequeststatus.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'71', N'25', N'Manage Payment Request Types', N'showAddPaymentrequesttype.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'72', N'1', N'Control Panel (CMRS Home)', N'showPageHeading.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'73', N'6', N'View Regions', N'showRegionList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'74', N'7', N'Manage Countries', N'showAddCountry.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'75', N'8', N'View Countries', N'showCountryList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'76', N'9', N'Manage States', N'showAddState.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'77', N'10', N'View States', N'showStateList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'78', N'11', N'Manage Field Offices', N'showAddFieldoffice.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'79', N'12', N'View Field Offices', N'showFieldofficeList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'80', N'14', N'View Donor Award Types', N'showDonorawardtypeList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'81', N'16', N'View Donor Award Statuses', N'showDonorawardstatusList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'82', N'18', N'View Project Types', N'showCipeprojecttypeList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'83', N'20', N'View Project Statuses', N'showCipeprojectstatusList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'84', N'26', N'View Payment Request Types', N'showPaymentrequesttypeList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'85', N'28', N'View Payment Request Statuses', N'showPaymentrequeststatusList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'86', N'22', N'View Partner Grant Types', N'showPageHeading.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'87', N'24', N'View Partner Grant Statuses', N'showPageHeading.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'88', N'30', N'View Account Codes', N'showAccountCodeList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'89', N'32', N'View KM Organization Types', N'showOrganizationtypeList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'90', N'33', N'Manage KM Organization Keywords', N'showAddKeyword.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'91', N'34', N'View KM Organization Keywords', N'showKeywordList.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'92', N'4', N'Add Partner Grant', N'showAddPartnergrant.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'93', N'5', N'Find Partner Grant', N'findCipeproject.do');
GO
INSERT INTO [dbo].[link] ([id], [displayorder], [displayname], [url]) VALUES (N'94', N'1', N'Knowledge Management', N'showPageHeading.do');
GO

SET IDENTITY_INSERT LINK OFF

SET IDENTITY_INSERT LINKCATEGORY ON

INSERT INTO [dbo].[linkcategory] ([id], [displayorder], [displayname]) VALUES (N'1', N'1', N'Donors and Donor Awards');
GO
INSERT INTO [dbo].[linkcategory] ([id], [displayorder], [displayname]) VALUES (N'2', N'3', N'Projects and Grants');
GO
INSERT INTO [dbo].[linkcategory] ([id], [displayorder], [displayname]) VALUES (N'3', N'7', N'Payment Processing');
GO
INSERT INTO [dbo].[linkcategory] ([id], [displayorder], [displayname]) VALUES (N'4', N'11', N'System Administration');
GO
INSERT INTO [dbo].[linkcategory] ([id], [displayorder], [displayname]) VALUES (N'5', N'9', N'Reports');
GO
INSERT INTO [dbo].[linkcategory] ([id], [displayorder], [displayname]) VALUES (N'11', N'8', N'Knowledge Management');
GO
INSERT INTO [dbo].[linkcategory] ([id], [displayorder], [displayname]) VALUES (N'12', N'10', N'Contact Us');
GO

SET IDENTITY_INSERT LINKCATEGORY OFF


INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'1', N'1');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'1', N'3');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'2', N'30');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'88');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'89');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'90');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'91');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'2', N'92');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'2', N'93');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'79');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'53');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'54');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'2', N'31');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'3', N'41');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'3', N'42');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'3', N'45');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'55');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'73');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'5', N'49');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'1', N'27');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'1', N'28');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'74');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'11', N'94');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'12', N'50');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'12', N'51');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'12', N'52');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'57');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'58');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'62');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'63');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'64');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'65');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'66');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'67');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'70');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'71');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'75');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'76');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'77');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'78');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'80');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'81');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'82');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'83');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'84');
GO
INSERT INTO [dbo].[categorylinks] ([linkcategoryid], [linkid]) VALUES (N'4', N'85');
GO



INSERT INTO dbo.stateprovince
        ( stateprovincecode ,
          stateprovincedesc ,
          createdate ,
          createdby ,
          lastupdated ,
          lastupdatedby ,
          countryid
        )
VALUES  ( 'DC' , -- stateprovincecode - varchar(25)
          'DC' , -- stateprovincedesc - varchar(50)
          '2012-01-21 19:35:14' , -- createdate - datetime
          1 , -- createdby - int
          '2012-01-21 19:35:14' , -- lastupdated - datetime
          1 , -- lastupdatedby - int
          186  -- countryid - int
        )
        
UPDATE dbo.donor 
SET state = 1

ALTER TABLE dbo.donor ALTER COLUMN state INT

ALTER TABLE dbo.fieldoffice ALTER COLUMN stateprovince INT

